﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="listAllGuestNameByDate.aspx.cs" Inherits="SWENAssignment.listAllGuestNameByDate" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
    <title></title>
    <style type="text/css">
        .auto-style1
        {
            height: 22px;
        }
        .auto-style2 {
            height: 30px;
        }
        .auto-style3 {
            height: 35px;
        }
    </style>
    </head>
<body style="background-color: #CCFFCC">
    <form id="form1" runat="server">
    <div>
    
        <table class="auto-style1">
            <tr>
                <td colspan="6">
                    <img alt="banner" class="auto-style6" src="../Images/jjw-dona-filipa-hotel-home-banner-01.jpg" /></td>
            </tr>
            <tr>
                <td colspan="6"><strong>WELCOME TO DELONIX REGIA HOTEL MANAGEMENT SYSTEM</strong></td>
            </tr>
            <tr>
                <td colspan="2">&nbsp;</td>
                <td>&nbsp;</td>
                <td>&nbsp;</td>
                <td>&nbsp;</td>
                <td>&nbsp;</td>
            </tr>
            <tr>
                <td colspan="2">
                    <asp:Menu ID="Menu1" runat="server" StaticSubMenuIndent="16px" style="font-size: large; font-weight: 700">
                        <Items>
                            <asp:MenuItem NavigateUrl="~/Homepage.aspx" Text="Homepage" Value="Homepage"></asp:MenuItem>
                            <asp:MenuItem NavigateUrl="~/Dennis/listOfAllRooms.aspx" Text="List of All Rooms" Value="List of All Rooms"></asp:MenuItem>
                            <asp:MenuItem NavigateUrl="~/Dennis/listAllDetailsByRoomNumber.aspx" Text="List of Guests Details by Room Number" Value="List of Guests Details by Room Number"></asp:MenuItem>
                            <asp:MenuItem NavigateUrl="~/Dennis/listAllGuestNameByDate.aspx" Text="List of All Guest Details in All Rooms By Date Range" Value="List of All Guest Name in All Rooms By Date Range"></asp:MenuItem>
                            <asp:MenuItem NavigateUrl="~/Dennis/reportingLogin.aspx" Text="Room Occupancy &amp; Housekeeping Report" Value="Room Occupancy &amp; Housekeeping Report"></asp:MenuItem>
                        </Items>
                    </asp:Menu>
                </td>
                <td>&nbsp;</td>
                <td>&nbsp;</td>
                <td>&nbsp;</td>
                <td>&nbsp;</td>
            </tr>
            <tr>
                <td colspan="2">&nbsp;</td>
                <td>&nbsp;</td>
                <td>&nbsp;</td>
                <td>&nbsp;</td>
                <td>&nbsp;</td>
            </tr>
            <tr>
                <td colspan="2">List all the Guests Details in All Rooms By Date Range</td>
                <td>&nbsp;</td>
                <td>&nbsp;</td>
                <td>&nbsp;</td>
                <td>&nbsp;</td>
            </tr>
            <tr>
                <td colspan="2">&nbsp;</td>
                <td>&nbsp;</td>
                <td>&nbsp;</td>
                <td>&nbsp;</td>
                <td>&nbsp;</td>
            </tr>
            <tr>
                <td colspan="2"><strong>Date</strong></td>
                <td>&nbsp;</td>
                <td>&nbsp;</td>
                <td>&nbsp;</td>
                <td>&nbsp;</td>
            </tr>
            <tr>
                <td class="auto-style2">Check-In:<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
                </td>
                <td class="auto-style2">Check-Out:<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
                </td>
                <td class="auto-style2"></td>
                <td class="auto-style2"></td>
                <td class="auto-style2"></td>
                <td class="auto-style2"></td>
            </tr>
            <tr>
                <td>
                    <asp:Calendar ID="Calendar1" runat="server" OnSelectionChanged="Calendar1_SelectionChanged" BackColor="White" BorderColor="#999999" CellPadding="4" DayNameFormat="Shortest" Font-Names="Verdana" Font-Size="8pt" ForeColor="Black" Height="180px" Width="200px" >
                        <DayHeaderStyle BackColor="#CCCCCC" Font-Bold="True" Font-Size="7pt" />
                        <NextPrevStyle VerticalAlign="Bottom" />
                        <OtherMonthDayStyle ForeColor="#808080" />
                        <SelectedDayStyle BackColor="#666666" Font-Bold="True" ForeColor="White" />
                        <SelectorStyle BackColor="#CCCCCC" />
                        <TitleStyle BackColor="#999999" BorderColor="Black" Font-Bold="True" />
                        <TodayDayStyle BackColor="#CCCCCC" ForeColor="Black" />
                        <WeekendDayStyle BackColor="#FFFFCC" />
                    </asp:Calendar>
                </td>
                <td>
                    <asp:Calendar ID="Calendar2" runat="server" style="margin-left: 0px" OnSelectionChanged="Calendar2_SelectionChanged" BackColor="White" BorderColor="#999999" CellPadding="4" DayNameFormat="Shortest" Font-Names="Verdana" Font-Size="8pt" ForeColor="Black" Height="180px" Width="200px">
                        <DayHeaderStyle BackColor="#CCCCCC" Font-Bold="True" Font-Size="7pt" />
                        <NextPrevStyle VerticalAlign="Bottom" />
                        <OtherMonthDayStyle ForeColor="#808080" />
                        <SelectedDayStyle BackColor="#666666" Font-Bold="True" ForeColor="White" />
                        <SelectorStyle BackColor="#CCCCCC" />
                        <TitleStyle BackColor="#999999" BorderColor="Black" Font-Bold="True" />
                        <TodayDayStyle BackColor="#CCCCCC" ForeColor="Black" />
                        <WeekendDayStyle BackColor="#FFFFCC" />
                    </asp:Calendar>
                </td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td colspan="2">&nbsp;</td>
                <td>&nbsp;</td>
            </tr>
            <tr>
                <td class="auto-style3">Customer&#39;s Details</td>
                <td class="auto-style3">&nbsp;</td>
                <td class="auto-style3"></td>
            </tr>
            <tr>
                <td colspan="2" class="auto-style3">
                    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" BackColor="White" BorderColor="#999999" BorderStyle="None" BorderWidth="1px" CellPadding="3" DataSourceID="SqlDataSource2" GridLines="Vertical">
                        <AlternatingRowStyle BackColor="#DCDCDC" />
                        <Columns>
                            <asp:BoundField DataField="checkInDate" HeaderText="checkInDate" SortExpression="checkInDate" />
                            <asp:BoundField DataField="checkOutDate" HeaderText="checkOutDate" SortExpression="checkOutDate" />
                            <asp:BoundField DataField="lastName" HeaderText="lastName" SortExpression="lastName" />
                            <asp:BoundField DataField="firstName" HeaderText="firstName" SortExpression="firstName" />
                            <asp:BoundField DataField="numOfAdults" HeaderText="numOfAdults" SortExpression="numOfAdults" />
                            <asp:BoundField DataField="numOfChildren" HeaderText="numOfChildren" SortExpression="numOfChildren" />
                            <asp:BoundField DataField="contNum" HeaderText="contNum" SortExpression="contNum" />
                            <asp:BoundField DataField="mailAdd" HeaderText="mailAdd" SortExpression="mailAdd" />
                            <asp:BoundField DataField="email" HeaderText="email" SortExpression="email" />
                        </Columns>
                        <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
                        <HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" />
                        <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
                        <RowStyle BackColor="#EEEEEE" ForeColor="Black" />
                        <SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
                        <SortedAscendingCellStyle BackColor="#F1F1F1" />
                        <SortedAscendingHeaderStyle BackColor="#0000A9" />
                        <SortedDescendingCellStyle BackColor="#CAC9C9" />
                        <SortedDescendingHeaderStyle BackColor="#000065" />
                    </asp:GridView>
                    </td>
                <td class="auto-style3"></td>
            </tr>
            <tr>
                <td colspan="2">
                    <%--<asp:SqlDataSource ID="CustomersDetails" runat="server" ConnectionString="<%$ ConnectionStrings:HotelManagementConnectionString %>" SelectCommand="SELECT [lastName], [firstName], [numOfAdults], [numOfChildren], [contNum], [mailAdd], [email] FROM [byDateRange] WHERE (([checkInDate] &gt;= @checkInDate) AND ([checkOutDate] &lt;= @checkOutDate))">
                        <SelectParameters>
                            <asp:ControlParameter ControlID="Calendar1" Name="checkInDate" PropertyName="SelectedDate" Type="String" />
                            <asp:ControlParameter ControlID="Calendar2" Name="checkOutDate" PropertyName="SelectedDate" Type="String" />
                        </SelectParameters>
                    </asp:SqlDataSource>--%>
                </td>
                <td>&nbsp;</td>
            </tr>
        </table>
    
    </div>
    <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:HotelManagementConnectionString %>" SelectCommand="SELECT [checkInDate], [checkOutDate], [lastName], [firstName], [numOfAdults], [numOfChildren], [contNum], [mailAdd], [email] FROM [byDateRange] WHERE (([checkInDate] &gt;= @checkInDate) AND ([checkOutDate] &lt;= @checkOutDate))">
        <SelectParameters>
            <asp:ControlParameter ControlID="TextBox1" Name="checkInDate" PropertyName="Text" Type="String" />
            <asp:ControlParameter ControlID="TextBox2" Name="checkOutDate" PropertyName="Text" Type="String" />
        </SelectParameters>
    </asp:SqlDataSource>
    </form>
</body>
</html>
